file system cache

Objective: Today a friend asked a question, the original text is as follows: Mysql5.1,myisam table, select COUNT (*) as total from m_bff WHERE from_uid= ' 73149293 ' and isdeleted=0. From_uid Index, the first time to execute this sentence slow,

A few days ago, see the innodb_flush_log_at_trx_commit的官网解释时产生了一些疑问，关于 detailed explanation of the innodb_flush_log_at_trx_commit parameters in the official

How does MySQL avoid using swap bitsCN.com? Loading editor... Source: http://www.realzyy.com/?p=923 Linux has many good memory and IO scheduling mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it

Innodb two-stage log Submission mechanism, innodb log submission ViewThe innodb_flush_log_at_trx_commit official website has some questions.For details about the innodb_flush_log_at_trx_commit parameter, refer to the official

Loading editor... Source: http://www.realzyy.com /? P = 923 Linux has many good memory and IO Scheduling Mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it does not avoid ing the address space

Linux has many good memory and IO Scheduling Mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it does not avoid ing the address space allocated to MySQL to swap because MySQL is very important. For

Linux has many good memory and IO Scheduling Mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it does not avoid ing the address space allocated to MySQL to swap because MySQL is very important. For

Linux has many good memory and IO Scheduling Mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it won't be caused by MySQL Linux has many good memory and IO Scheduling Mechanisms, but they are not

InnoDB two-phase log Submission mechanism ViewThe innodb_flush_log_at_trx_commit official website has some questions.For more information about the innodb_flush_log_at_trx_commit parameter, see the official website.One of them is written as follows:

How MySQL avoids using the swap partition of Linux to improve read and write performanceLinux has a lot of good memory, IO scheduling mechanism, but it does not apply to all scenarios. One of the headaches for DBAs is that it doesn't have to be that

How does MySQL avoid using swap Original article: www.taobaodba.comhtml552_mysql_avoid_swap.html? Linux has many good memory and IO Scheduling Mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it

This method is extremely useful for the following applications: Write-intensive high-speed cache placed before a slow RDBMS System Embedded System PCI compatible systems without persistent data Unit testing, which requires a lightweight database and

In the process of daily operations, we often encounter the lack of swap space, and even nagios to swap monitoring as a basic system monitoring items, enough to see the importance of this performance indicators.In general, MySQL database machine is

The storage Engine (Storage) is the core component of MongoDB, responsible for managing how data is stored on the hard disk and memory. Starting with the MongoDB 3.2 release, MongoDB supports the multi-data storage engine (Storage engines), and

Original: https://jin-yang.github.io/post/mysql-group-commit.htmlGroup commit is to optimize the brush disk problem when writing logs, from initially supporting only the InnoDB Redo log group submission, to the 5.6 official version support redo log

Before May 1, a DBA reported that a large slow log file was deleted in the daily environment (assuming the file size is more than 10 GB ), then execute flush slow logs in MySQL and you will find mysqld hang. I tried to reproduce this problem today.

A dba reported that a large slow log file was deleted in the daily environment before MySQLLogs was deleted (assuming the file size is more than 10 GB ), then execute flush slow logs in MySQL and you will find mysqld hang. I tried to reproduce this

http://blog.itpub.net/28218939/viewspace-1975809/Ma Pengfei Technology MySQL database engineer MySQL binary log was launched after MySQL version 5.1, which is mainly used for primary and standby replication, and we review how MySQL works when

Recently, during the test, we found that during map reduce data analysis, the CPU sys occasionally rose to 50% or even, causing severe jitter. The disk Io throughput of the node is relatively large, reaching 150 MB per second. Most of the

A buffer is something that have yet to being "written" to disk. A cache is something that have been "read" from the disk and stored for later use. For a more detailed explanation reference: difference between Buffer and Cache The difference between